How to: Combine text and a field in a text box.
Solution:
In the Report Design view, use the 'Control Source' property box in the property sheet to combine text and a field in a text box.
1) If the Database window is not active, activate the Database window.
2) Click the 'Reports' tab in the Database window.
Reports tab
3) Select the desired report from the list box. (The selected report is highlighted.)
4) Click 'Design'. (The selected report appears in the Design view, and the floating Toolbox appears.)
5) Click on the desired control to add text. (Handles appear around the control.)
6) Select the 'View' menu and select 'Properties'.
7) Click the 'Data' tab.
8) Click on the 'Control Source' box.
NOTE: If an incorrect control is selected, the 'Control Source' is not an option.
9) Type the desired expression that combines the appropriate text and fields.
EXAMPLE: Combining text with fields
10) Select the 'File' menu and select 'Save' to save the report.
